# Permissions

The user specified in the endpoint settings must be granted access to the Netezza Performance Server (NPS) account as well as the privileges listed below.

## Database privileges

* LIST on <database> to <Replicate user>
* SELECT on <database> to <Replicate user>

## Table privileges

* CREATE TABLE to <Replicate user>
* LIST on TABLE to <Replicate user>

## Schema privileges

* CREATE SCHEMA to <Replicate user>
* LIST on SCHEMA to <Replicate user>

## View privileges

* SELECT on \_T\_DATABASE to <Replicate user>
* SELECT on \_V\_SCHEMA to <Replicate user>
* SELECT on \_V\_USER to <Replicate user>
* SELECT on \_V\_TABLE to <Replicate user>
* SELECT on \_V\_TABLE\_DIST to <Replicate user>
* SELECT on \_V\_RELATION\_KEYDATA to <Replicate user>
* LIST on \_T\_DATABASE to <Replicate user>
* LIST on \_V\_SCHEMA to <Replicate user>
* LIST on \_V\_USER to <Replicate user>
* LIST on \_V\_TABLE to <Replicate user>
* LIST on \_V\_TABLE\_DIST to <Replicate user>
* LIST on \_V\_RELATION\_KEYDATA to <Replicate user>